package cn.com.api.mapper.base;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import cn.com.api.entity.ApiT_configuration;

//DAO
public interface T_configurationMapperBase {

	// 根据id查看
	@Select("SELECT * FROM t_configuration  WHERE id = #{id}")
	public ApiT_configuration findT_configurationById(Integer id);

	// 查看数据集
	@Select("SELECT * FROM T_configuration")
	public List<ApiT_configuration> findT_configurations();

//	// 添加
//	@Insert("INSERT INTO t_configuration (fieldname, fieldvalue, remark) VALUES (#{fieldname}, #{fieldvalue}, #{remark})")
//	public int insertT_configuration(ApiT_configuration t_configuration);

	// 修改
	@Update("UPDATE t_configuration SET fieldname = #{fieldname}, fieldvalue = #{fieldvalue}, remark = #{remark} WHERE id = #{id}")
	public int updateT_configuration(ApiT_configuration t_configuration);

	// 删除
	@Delete("DELETE FROM t_configuration  WHERE id = #{id}")
	public int deleteT_configuration(Integer id);

}
